LUMPER LOG · TRAINING GUIDE · NOTS LOGISTICS
TRAINING GUIDE
Lumper Log
CWT weight and hourly labor tracking for the contingent lumping crew. This guide covers every function of the app, step by step, for each access profile: Associate, Supervisor, and Admin.
How pay works in the app
Crew are paid CWT (hundredweight) while checked into a load, and hourly for the rest of their clocked-in shift. The app separates the two automatically: time on a load counts as CWT work, and the remaining shift time is hourly, which supervisors break down by labor category. All time rounds to the quarter hour: 7 minutes or less rounds down, 8 or more rounds up (6:07 → 6:00, 6:08 → 6:15). Overtime applies past 40 hours in a week; CWT earned past 40 hours pays at the overtime CWT rate.
Access profiles
| ROLE | WHAT THEY SEE | WHAT THEY CAN DO |
|---|---|---|
| Associate | Their own load board only | Log in with PIN (clocks them in), accept assigned loads, check in and out of loads, see their own week and estimated pay |
| Supervisor | Log, Approvals, Floor board, Crew week, Labor mix, Crew roster, Associate view | Everything an associate can, plus: post and open loads, assign crew, approve loads, categorize labor, manage the roster, PINs and roles, submit the week |
| Admin | Everything, including Billing and Rates | Everything a supervisor can, plus: billing summary, pay and charge rates, labor task rates, database sync, approving and locking weeks |
Every user logs in with a 4-digit PIN set by a supervisor on the Crew roster tab. PINs are personal — logging in as someone else puts your time on their pay.
1 · Associate guide
ASSOCIATE
Logging in (this clocks you in)
1
Open the app. You will see the dark PIN screen.
2
Check the site shown in the dropdown is your site.
3
Enter your 4-digit PIN on the keypad. It submits automatically on the fourth digit.
4
You are now clocked in for the day. Your shift clock starts the moment you log in.
Accepting an assigned load
If a supervisor assigned you a load, a card appears right after login: LOAD ASSIGNED TO YOU with the account, trailer, door, and weight.
1
Read the load details and who you are assigned with.
2
Tap Accept & start. This checks you into the load and starts your time on it. Tap Not yet only if you cannot start immediately — the load stays assigned to you.
While you have an assigned load waiting, you cannot check into any other load. Other loads show “Finish your assigned load first.”
Checking in and out of loads
1
On your board, find the load under Loads on the floor. Each card shows the account, direction, trailer, door, weight, who else is on it, and your projected CWT share.
2
Tap Check in when you start working the trailer. Your CWT time starts.
3
Tap Check out when the trailer is done. When the last person checks out, the load goes to the supervisor for approval.
4
Loads marked PEND in My entries are awaiting approval and are not in your pay yet.
Your day clock and pay
- The Day clock card shows your shift status: when you clocked in, how long you have been on shift, and whether you are currently on a load (CWT) or on hourly time.
- My week shows your CWT, hours, overtime hours, and estimated pay for the week.
- Weight on a load splits evenly across everyone checked into it.
Logging out
1
Check out of your load first — you cannot clock out while on a load.
2
Tap Log out (top right). When asked “Clock out for the day too?” choose OK at end of shift, or Cancel if you are only stepping away and staying on the clock.
2 · Supervisor guide
SUPERVISOR
Logging in
Enter your supervisor PIN on the PIN screen. You land on the Log tab with the full tab bar. The site and pay period selectors are in the dark header; the status pill (Draft / Submitted / Approved) shows the current week’s state.
Log tab — posting and opening loads
1
Pick the date with the calendar field. The feed on the right shows everything already logged that day.
2
Enter trailer/BOL, door number, pick the account and direction, and enter the weight in pounds from the BOL.
3
Select the crew. The panel shows total CWT, CWT each, and pay each before you commit. Use Everyone / Clear shortcuts.
4
Choose one of two buttons: Open for check-in creates a live load and assigns the selected crew (they must accept and check in themselves) — use this during the day. Post load writes the load directly with the selected crew — use this for after-the-fact entry.
Weights under 1,000 lb or over 60,000 lb ask for confirmation — check for typos before accepting.
Log tab — categorizing remaining labor
Hourly time comes from the shift clock automatically. Your job is to say what that hourly time was. The Categorize remaining labor form lists only crew who still have unclassified hours for the selected day, with the amount on each chip (e.g. “2.75h left”).
1
Pick the category (Rack Management Unskilled, Dock Forklift, Taping, Rack Untwisting, 5S…).
2
Select the people. Leave hours blank to tag each person’s full remaining time, or enter hours each for a partial amount.
3
Tap Add hours. Anything left untagged still pays hourly and shows as “Untagged shift time” in the labor mix until you categorize it.
Approvals tab
When the last associate checks out of a load, it lands here. Nothing counts toward pay or billing until approved.
1
Review each card: every person’s in time, out time, time on load, and CWT share.
2
Approve + post counts it. Send back reopens it for the crew to fix. Reject deletes it. Approve all clears the queue at end of shift.
3
The Open on the floor panel shows live loads. Use the dropdown to assign more people, remove assigned people (names with a ✓), or Close out a load for the crew.
Floor board tab (wall display)
Put this on the dock TV. One row per open door: door, account, trailer, weight, status, who is on it with running time, start, and elapsed. Amber rows are waiting for crew. The ASSIGN dropdown in each row assigns associates to that load — whether they are clocked in or not; they confirm the assignment when they log in. Clicking a highlighted ✓ name removes them.
Crew week tab
- One row per person: CWT regular/OT, hours regular/OT, CWT pay, hourly pay, total pay (2 decimals, quarter-hour rounded).
- Amber rows are within 4 hours of overtime; red rows are past 40 hours.
- Export .xlsx downloads the payroll workbook: a Payroll Totals tab plus one tab per crew member, in the same layout as the paper workbook.
Crew roster tab
1
Add someone: enter name and date of hire, tap Add to crew. They join this week and become selectable immediately. Set their PIN right away.
2
PIN and role columns: type a 4-digit PIN; pick Associate, Supervisor, or Admin. This is where all app access is controlled.
3
On crew / Off controls this week only. Active / Inactive keeps someone out of every new week but preserves history. Delete is blocked once they have entries — deactivate instead.
4
Bulk actions: put every active person on, clear all except who has entries, or copy last week’s roster.
Submitting the week
1
Confirm approvals are cleared and labor is categorized (check Labor mix for an “Untagged shift time” bucket).
2
Tap Submit week in the status bar. The week goes to the office as Submitted. Once the office approves, it locks and entries become read-only.
3 · Admin guide
ADMIN
Admins see everything supervisors see, plus Billing and Rates, and handle the week’s final approval.
Billing tab
- Weight handled by account: inbound/outbound pounds, CWT, and charge per account at the site’s per-pound rate.
- Hourly labor billed: hours by category at each task’s bill rate, including any untagged shift time.
- The dark panel totals receivable, subtracts crew payable, and shows receivable less payable for the week.
- Invoice backup generates the per-account detail for customer invoicing.
Rates tab
- Payable to crew: CWT regular and overtime (per hundredweight), hourly regular and overtime. Two decimals.
- Billable to customer: weight charge per pound (4 decimals) and labor charge per hour.
- Hourly labor tasks: add, rename, archive, or delete task categories; set a per-task bill rate (blank bills at the site rate). Tasks with logged hours can only be archived, not deleted.
- Rates are per site — switch sites in the header to edit the other site’s rates.
Approving and locking a week
1
When the supervisor submits, the status pill reads Submitted · awaiting office.
2
Review Crew week and Billing. Tap Approve + lock. The week locks; entries and roster become read-only.
3
Use Reopen if a correction is needed, then re-submit and re-approve.
Database sync (Supabase)
1
In Supabase, open the SQL editor and run the contents of supabase-schema.sql once.
2
On the Rates tab, paste the project URL and anon key into the Database sync card and tap Save & connect.
3
Status shows “Connected · syncing.” Every change now saves to the database and loads on startup on any device.
4 · Quick reference
Rules the app enforces
| RULE | WHAT IT MEANS |
|---|---|
| Login = clock in (associates) | The shift clock starts at PIN entry and drives hourly pay. |
| No load work off the clock | Associates must be clocked in to check into a load. |
| Assigned load comes first | An unaccepted assignment blocks check-in to any other load. |
| Approval before pay | Checked-out loads count nowhere until a supervisor approves. |
| Even CWT split | Load weight divides evenly across everyone checked in. |
| Quarter-hour rounding | All time rounds to 0.25h: ≤7 min down, ≥8 min up. |
| OT over 40 hrs/week | Hourly OT rate applies past 40; CWT past 40 pays the OT CWT rate. |
| Locked week = read-only | After office approval nothing can change until reopened. |
Who to call
- Wrong PIN / locked out: your site supervisor (Crew roster tab).
- Load posted wrong: supervisor can remove it from the day feed and re-post while the week is unlocked.
- Rate or billing question: site admin (Rates and Billing tabs).